KR100398453B1 - Operation system - Google Patents

Abstract

The present invention relates to a system configuration and operation method for implementing business-to-business (B2B) business, and more specifically, unlike the existing single site e-commerce or simple connected e-commerce, from the infrastructure structure systematically It is about a system to integrate.

To this end, this system uses three element technologies.

The metadata management technology is a list of data related to metadata of each e-commerce application distributed through the Internet, that is, data dictionary metadata that manages schema information, user information, and organization information of each application, and location information of systems and resources. A technology for managing metadata. Distributed heterogeneous database (DB) interworking technology requires the integration of multiple systems due to the nature of business-to-business electronic commerce (B2B), and these systems are often distributed on different platforms, different operating systems (OSs), and different systems in a distributed environment. It is developed as an implementation language. There is also a need for technology that can track the progress of the entire system or monitor and control the overall workflow.

The present invention is characterized by configuring a system that is more normalized and actively copes with change by implementing B2B between companies using such a technology.

Accordingly, according to the present invention, the local database is integrated and managed through metadata, thereby providing transparency to the user and providing the convenience of management to the administrator since it has the flexibility to proactively cope with changes in the future requirements. It is effective.

Metadata: Data used to describe or represent a set of data. Metadata is the equivalent of a schema in a database or object-oriented programming.

Schema: A method used to represent a large amount of data managed by a DBMS through the name database in a database system. In other words, the term refers to the logical structure of a database that expresses information about the structure and content of data in the database and the logical and physical characteristics of those data. In general, a database expresses a database using a schema of several layers for data independence.

Description

Electronic commerce system with integrated program to integrate systematically from infrastructure

The present invention relates to an electronic commerce system with a program that integrates systematically from the infrastructure. For this purpose, the system uses three element technologies: metadata management technology, distributed heterogeneous database interworking technology, and monitoring and control technology. Implementing electronic commerce (B2B) creates a more normalized and proactive system to respond to change.

At present, a similar method has been attempted to establish CALS or IDB, but even a reference model has not yet been established. Moreover, it is the first in Korea for e-commerce between enterprises.

Because of the nature of business-to-business (B2B) integration, it is essential to integrate multiple systems, and these systems are often developed in different platforms, different operating systems (OSs), and different implementation languages in a distributed environment. In addition, there are various data sources, such as general BOM data such as companies and transactions, drawing data such as parts DB, and document data such as quote DB, and finding the desired data from different types of data sources is usually complex data that combines various data. Most likely, these data are heterogeneous databases but have relationships with each other. To solve this problem, interworking between heterogeneous data and databases is essential. For this, wrapper technology and monitoring technology are used. Wrapper technology is a conversion technology of various DBMSs and data sources, and monitoring technology is a technology that can understand and control the flow of work.

Integrating the system for electronic business commerce (B2B) requires the management of data dictionaries and data lists generated from each application data. Data dictionary technology refers to a technology that manages and stores schema information, organization, and user information of application data at the upper level of application data, and shares and utilizes it in each application, and data directory technology is distributed. It refers to technology that manages location information, organization information, member information, etc. of existing systems and resources. Existing systems did not consider the management of such metadata, but only concerned with the application data, and had many problems in terms of management of the entire system.

* DBMS: Short for Data Base Management System, refers to hardware and software that handles database management. You can create database files, add data to files, change existing data, retrieve data, and so on. It is a software system that handles all access to the configuration and use of the database, providing the ability to organize, process, and control data in response to database user requests. In other words, it is a set of functions necessary for constructing and maintaining a database so that it can be provided to a user. A database user can use a database through a database management system. The purpose is to make the searching, updating, and management of data easier and more efficient, as well as to improve productivity and economics, by making the file aware of the work program creator.

Accordingly, the present invention has been made to solve the above-mentioned conventional problems, the object of the present invention is to build a business-to-business electronic commerce, beyond the level of interworking of simple sites, interworking heterogeneous platforms, interworking distributed heterogeneous databases, By linking programs developed in different languages, it is to provide a system in which a physically independent system is logically integrated into a single system.

In addition, the present invention is to provide an environment that can be utilized in the construction of electronic commerce the element technologies required to build the current integrated system.

1 is a block diagram of an entire system interworking with each commerce application, a metadata management system (information store system), and a distributed database in an Internet distributed environment according to the present invention.

2 is a flowchart of a net auction system in which a sales member according to the present invention pulls out necessary parts by a cross checking method to a purchasing member and calculates an estimate thereof.

3 is a flowchart of a system in which a purchasing member according to the present invention searches for necessary parts by a cross checking method to a sales member and orders them online.

4 is a flow diagram of a metadata management system in accordance with the present invention.

5 is a flowchart of a distributed heterogeneous database interworking system according to the present invention;

6 is a flow chart of a system for on-line quote / purchase according to the present invention.

<Description of the symbols for the main parts of the drawings>

10: Internet 20: Information Store Browser

30: management tool 40: application

50: information storage system 60: integrated DB

100: data dictionary DB 200: data list DB 300: inventory DB

400: Purchase DB 500: Member DB 600: Quote DB

700: excessively insoluble DB 800: order status DB 900: order history DB

In order to achieve the above object, according to a first aspect of the present invention, in the system for systematically integrating from the infrastructure for the inter-company electronic commerce implementation,

Multiple client computers;

An operator site connected to the plurality of client computers via a network to exchange information data with each other;

A web browser programmed to create, store, print, and display a document in a predetermined language and form on a network, and to form a communication line with external and networks;

A web server programmed to input, output, retrieve, store, and modify information data between a plurality of client computers and the operator site through a network;

A data dictionary system programmed to implement a data dictionary technology that manages and stores the schema information of the application data and the meta information of the metadata on the upper part of the application data and shares and utilizes them in each application data;

A data list system programmed to implement a data list technology for managing location information, organization information, and client information of distributed systems and resources;

A metadata system programmed to interface the data by the data dictionary system and the data by the data catalog system with the client computer via a network and to drive an information repository browser for inputting, searching, storing and modifying the data;

A member management system that makes a database of information about a company registered as a member company by a predetermined method provided by the operator site, and inputs, searches, stores and modifies it;

An inventory database storing goods owned by a member company that intends to sell goods through the operator site;

A purchase database storing product information provided to member companies who want to purchase a product through the operator site;

Quotation database for storing quotations for the goods managed through the operator site;

An integrated system programmed to interwork the inventory database and the purchase database to create an integrated database, and to search the database by a cross-checking method;

An application system for managing a web browser and a site connected to the operator site through a network;

A management tool system programmed to monitor and control the data exchange between the operator site and a plurality of clients connected via a network; It is made by including a configuration.

Hereinafter, preferred embodiments of the present invention will be described with reference to the accompanying drawings.

The present invention is divided into three parts: forward auction, reverse auction, and online quotation / purchase.

1 is a block diagram of an entire system linked to each commerce application, a metadata management system (information store system), and a distributed database in an Internet distributed environment according to the present invention.

The interface consists of each application application 40, management tool 30, information store browser 20, which is the only interface for the administrator to access the information store data. It is not used by normal users, and administrators can insert, delete, modify, and retrieve metadata through this interface. Management tools are tools that allow you to monitor the progress of the entire system, or control purchases or quotations. The application is a typical e-commerce site.

Each application data is generated and stored in each local database at the same time, and corresponding schema information, meta schema information, user information, and organization information are stored in an information storage system 50 in another region through a network. When the data structure of each application data is changed, these changes and location information are recorded and stored in the information storage system. The stored information is managed through the data dictionary system of the information storage system during data management, and each distributed resource gets its name independent of its physical location through the information stored in the data list of the information storage system. It can be accessed through information. The information storage system maintains its own data dictionary DB (100) and data list DB (200), and the local database is inventory DB (300), purchase DB (400), member company DB (500), quotation DB (600). Consists of The inventory DB is a DB that stores goods owned by a sales member, and the purchase DB is a DB which stores goods information that a purchasing member wants to find. The member company DB is a DB that stores the information of each member company and the quotation DB is a DB that stores the quotations for the goods. The inventory DB and the purchase DB are interlocked with each other in the form of an integrated DB 60, and are configured to search for data matching the stock information and the purchase information by searching by a cross checking method.

2 is a flowchart of a net auction system in which a sales member according to the present invention pulls out necessary parts by a cross checking method to a purchasing member and calculates an estimate thereof. The sales member and the purchasing member register their respective inventory information and purchase information, and the sales member performs cross-checking search by looking at the goods owned by the sales member and the purchase information of the purchasing member requesting the purchaser. After the search, if there is a search result, the quotation is processed. If there is no search result, there is no purchase member requesting this, and these data are stored in the excessively insoluble DB 700. Quotation processing retrieves the purchase member information from the member company DB (500), calculates an estimate with these data, stores it in the quotation DB (600), and delivers it to the purchase member company. The purchasing member is configured to read the quotation made by the sales member from the quotation DB and take appropriate action.

3 is a flowchart of a system in which a purchasing member according to the present invention searches for necessary parts by a cross checking method to a sales member and orders them online. Sales member and purchasing member register each stock DB (300) and purchase DB (400), and purchasing member sees the purchase information that the purchasing member wants to find and searches through the stock DB to search online if there is a search result. Quotation process by the purchase method / get the sales member's information from the member company DB (500) to create a quotation and deliver it to the sales member company. If there is no search result, the excess insoluble DB 700 is searched, and if there is no search result in the excess insoluble DB, it is configured to store it in the purchase parts purchase DB and expect the access of the sales member in the future.

4 is a flowchart of a metadata management system according to the present invention. Since the metadata management system has little effect on the application system, the management system of the entire system is stronger than the application of each system. The administrator accesses the information storage system through the information storage browser and is configured to insert, delete, modify, and search metadata.

In the application system, the sales member company and the purchase member company of FIGS. 2 and 3 play a role of resolving access to the corresponding user authentication information or each resource.

5 is a flowchart of a distributed heterogeneous DB interworking system according to the present invention. If you need to search the inventory DB (300) stored by the sales member and the purchase DB (400) stored by the purchasing member at the same time, you need to cross-check and search the inventory DB and the purchase DB. It is configured to be organized and searchable.

6 is a flowchart of an online quotation / purchasing system according to the present invention. (1) The purchase member who wants to purchase the product searches for the desired parts in the stock parts DB 300, and if there are parts, processes the order and registers them in the order status DB 800. (2) The B2B providing site updates the status after viewing the order status and stores these order history information in the order history DB 900. If there are no parts, the purchasing member requests a quotation from the B2B provider site, and the B2B provider site connects offline with the business partner to send a quotation processing reply by e-mail. When the order is placed, the information is stored in the order status DB. Update the status and progress if there is an inventory DB. (3) Order status information is composed so that you can search the progress result and status at any time.

As described above, according to the present invention, since the local database is integrated and managed through metadata, it provides transparency to the user and has the flexibility to proactively cope with changes in the requirements later. It is effective to provide.

At present, a similar method has been attempted to establish CALS or IDB, but even a reference model has not yet been established. Moreover, it is the first in Korea for e-commerce between enterprises. Such a system configuration and operation method will not only become a reference model for establishing a large scale e-commerce between enterprises in the future, but if it is implemented based on this, its scalability will be great.

* CALS: CALS stands for Commerce At Ligted Speed, which digitizes all the information that a company has, from design to development, procurement, production, sales and logistics, to standards and then to the company. It refers to a corporate informatization system that is shared between people and even internationally. By sharing information, it leads to a system that can reduce inefficiency caused by duplication of various drawings or distortion of transmission process. It is a production strategy to reduce informatization management, reduce costs and increase productivity. In 1993, the United States Department of Defense and defense companies led the development of a complex logistics support system for efficient management using information technology.In the beginning, it was used as a computer integrated logistics system. It is widely used in the sense of commerce.

Claims (3)

In the system that systematically integrates from the infrastructure for the implementation of e-commerce between enterprises, Multiple client computers; An operator site connected to the plurality of client computers via a network to exchange information data with each other; A web browser programmed to create, store, print, and display a document in a predetermined language and form on a network, and to form a communication line with external and networks; A web server programmed to input, output, retrieve, store, and modify information data between a plurality of client computers and the operator site through a network; A data dictionary system programmed to implement a data dictionary technology that manages and stores the schema information of the application data and the meta information of the metadata on the upper part of the application data and shares and utilizes them in each application data; A data list system programmed to implement a data list technology for managing location information, organization information, and client information of distributed systems and resources; A metadata system programmed to interface the data by the data dictionary system and the data by the data catalog system with the client computer via a network and to drive an information repository browser for inputting, searching, storing and modifying the data; A member management system that makes a database of information about a company registered as a member company by a predetermined method provided by the operator site, and inputs, searches, stores and modifies it; An inventory database storing goods owned by a member company intending to sell goods through the operator site; A purchase database storing product information provided to member companies who want to purchase a product through the operator site; Quotation database for storing quotations for the goods managed through the operator site; An integrated system programmed to interwork the inventory database and the purchase database to create an integrated database, and to search the database by a cross-checking method; An application system for managing a web browser and a site connected to the operator site through a network; A management tool system programmed to monitor and control the data exchange between the operator site and a plurality of clients connected via a network; E-commerce system with a built-in program to integrate systematically from the infrastructure, characterized in that comprises a. delete delete