What are the differences between the methods and results of a database and search engine search

The wave of enterprise informatization construction has given birth to a large number of internal information resources. According to statistics, enterprise data grows at a rate of 200% every year, of which 80% of the data is stored in all corners of the computer system in the form of files, emails, ** and other unstructured data, and the total amount of these data far exceeds the total amount of Internet information. The integration of enterprise information resources, the construction of enterprise search engines, and the provision of retrieval and personalized information services for internal and external users have become a hot spot in enterprise informatization.

1. The problem of slow speed when the amount of information is large.

The more commonly used databases are: oracle, mysql, ms sql, etc., these are databases that support standard sql92 syntax, the key function of the database is storage, for the amount of data reaches tens of millions, the speed of executing sql syntax will become very slow, especially when executing select statements containing like, for example, when the data record of a customer information table stored by mysql reaches more than 5 million rows, even if more indexes are added, When the query is executed using the standard select statement, the time required is at least 2 minutes, and the time required for Oracle database can be partitioned or Oracle built-in functions such as instr to assist the query, which is more than 1 minute.

Dameng database search engine uses full-text search technology to solve the problem of search speed, which is why Google can search from hundreds of millions of web databases, and only need to return results within a few tenths of a second.

Why can the Dameng database search engine return results in 0.00 seconds when searching? Read records from the database, divide the fields to be searched, save them as a file index, and then divide the words when searching, and directly go to the index to find out which indexed documents each word has.

2. There are many forms of information.

If you want to build an industry information base, such as a news library, it may be divided into many categories, such as: Internet, application software, communications, etc., each category may be organized by a department, and may involve various departments, including not only text, **, charts and ** and other forms of information resources, but also cover information resources in other languages. Dameng database search engine can provide a unified cross-** search.

3. The information structure is different.

If there are many information systems in the past, and the databases are different, they are also developed in different languages, and the query of A information has to go to system A, and the query of class B information has to go to system B to query, one is inconvenient to query, and the other is that there are many duplicate data, and it is impossible to make full use of these existing data resources.

From the point of view of search methods, search engines are convenient and easy to use, only need to enter keywords to search, and most of the search engines are free to find existing web pages on the Internet, which is a search method that everyone can use; However, the use of professional databases is more cumbersome and complicated, and requires a certain amount of relevant knowledge to be used, and professional databases are charged and need to be purchased specifically.

Judging from the search results, the search engine can search for a large number of articles that already exist on the Internet, including both special ** and related news or the opinions of some netizens, the relevance and authority are poor, but the information covers a wide range; The professional database only includes the ** in various academic journals and the graduation of some students**, and the information coverage is smaller, so the relevance and authority of the articles in the professional database are higher than those of search engines.

Review:

Think about the difference between a search engine and a professional database: the division of responsibilities is different. The search engine is mainly composed of four parts: searcher, indexer, retriever and user interface, which should ensure the richness of information.

The main responsibility of the database is to ensure that the system operates reliably and that failures can be quickly eliminated.

The key technologies are different. Search engine technology is mainly external, through SEO such a set of search engine-based marketing ideas, to provide ecological self-marketing solutions, so that the best in the industry to occupy a leading position, so as to obtain brand benefits. The data database technology is a computer-aided data management method, which studies how to organize and store data, and how to obtain and process data efficiently.

A database is a repository of data. It has a large storage space and can store millions, tens of millions, and hundreds of millions of pieces of data. However, the database does not store data at will, there are certain rules, otherwise the query efficiency will be very low.

Today's world is an internet world full of data, and it is full of data. That is, this Internet world is the world of data. There are many types of data, such as travel records, consumption records, web pages browsed, messages sent, and so on.

In addition to text-type data, images, **, and sounds are all data.

A database is a computer software system that stores and manages data in a data structure. The concept of database actually includes two meanings: a database is an entity, it is a "warehouse" that can reasonably keep data, and users store transaction data to be managed in this "warehouse", and the two concepts of "data" and "library" are combined to form a database.

Databases are a new approach and technology for data management, which allows for better organization of data, easier maintenance of data, tighter control of data, and more efficient use of data.

The differences are as follows:

search engines) is a system that collects and sorts out information resources on the Internet and then provides you with queries, which includes three parts: information collection, information collation and user query. A search engine is a "search" service that provides you with information**, which uses certain programs to categorize all the information on the Internet to help people search for the information they need in the vast sea of the Internet.

2. Online retrieval is the process in which people connect the terminal equipment with the computer retrieval system through the communication network, and use the man-computer dialogue mode to find the information required from the host. For example, Wanfang.

Tongfang, VIP, etc.

Its advantages are strong retrieval function, huge information resources, timely data update, reliable information sources, and fast retrieval speed.

A search engine consists of four parts: a searcher, an indexer, a searcher, and a user interface. The function of the search engine is to roam the Internet, discover and gather information. The function of an indexer is to understand the information searched by the searcher, extract the index items from the chain trap, and use it to represent the document and generate the index table of the document library.

The function of the retriever is to quickly check out documents in the index database according to the user's query, evaluate the relevance of the document and the query, sort the results to be output, and implement a certain user relevance feedback mechanism. The role of the user interface is to enter user queries, display query results, and provide user relevance feedback mechanisms.

Similarities: 1. The number of shirts is a database. It collects tens of millions to billions of web pages on the Internet and indexes every word (i.e., keyword) in the web page, and establishes a full-text search engine that indexes the database.

2. It's all software technology. They are all systems that use specific computer programs to collect information from the Internet, organize and process the information, provide users with retrieval services, and display the relevant information retrieved by users to users.

3. They are all built for use. They include full-text indexing, directory indexing, metasearch engines, metasearch engines, metasearch engines, aggregate search engines, portal search engines, and free link lists, which can be regarded as the latest generation of network sharing.

The main responsibility of the database is to ensure that the system operates reliably and can be quickly eliminated in the event of a failure.

2. The key technologies are different. Search engine technology is mainly external, through SEO such a set of search engine-based marketing ideas, to provide ecological self-marketing solutions, so that the best hall in the industry to occupy a leading position, so as to obtain brand benefits. Database technology, on the other hand, is a computer-aided method of managing data, which studies how to organize and store data, and how to obtain and process data efficiently.

Although there are similarities and differences between the two, they complement each other.